create external table jms_ods.tab_rou_main_city(
province        string comment "省份"       --NVARCHAR2(60)
,province_id     string comment "省份ID"       --NVARCHAR2(20)
,city            string comment "城市"       --NVARCHAR2(60)
,city_id         string comment "省份ID"       --NVARCHAR2(20)
,area            string comment "区县"       --NVARCHAR2(60)
,area_id         string comment "区县ID"       --NVARCHAR2(20)
,create_time     timestamp comment "创建时间"    --   DATE
,modify_time     timestamp comment "最后更新时间"    --   DATE
,create_by       string comment "创建人"       --NVARCHAR2(20)
,create_by_id    string comment "创建人ID"       --NVARCHAR2(20)
,modify_by       string comment "修改人"       --NVARCHAR2(20)
,modify_by_id    string comment "修改人ID"       --NVARCHAR2(20)
,id              string comment "主键ID"       --NVARCHAR2(40)
,bind_site_code  string COMMENT '绑定网点编号'  --NVARCHAR2(30)
,bind_site_name  string COMMENT '绑定网点名称'  --NVARCHAR2(60)
,is_main      smallint COMMENT '是否主城区1-是，2-否'   --NUMBER(2)
)
comment "主城区表，非BI表"
partitioned by(dt string comment "分区字段:数据录入日期")
stored as parquet
location "/dw/hive/jms_ods.db/external/tab_rou_main_city";